Capitalizes the first letter in a text string and any other letters in the text string that follow any character other than a letter. Converts all other letters to lowercase letters.
Syntax
PROPER(text)
Text is text enclosed in quotation marks, a formula that returns text, or a reference to a cell containing the text you want to partially capitalize.
Example
The example may be easier to understand if you copy it to a blank spreadsheet.
Selecting an example from Help
Data | |
---|---|
this is a TITLE | |
2-cent's worth | |
76BudGet | |
Formula | Description (Result) |
=PROPER(A2) | Proper case of first string (This Is A Title) |
=PROPER(A3) | Proper case of second string (2-Cent'S Worth) |
=PROPER(A4) | Proper case of third string (76Budget) |